package com.cskaoyan.demo10.mapper;

import com.cskaoyan.demo10.bean.Course;
import com.cskaoyan.demo10.bean.Student;

public interface StudentMapper {
    // select id,name from cskaoyan_student where name = '刘星';
    Student selectByName(String name);
    // select
    //s.id,
    //s.name,
    //c.id cid,
    //c.name cname
    // from cskaoyan_student s
    //LEFT JOIN cskaoyan_relation r on s.id = r.stu_id
    //left join cskaoyan_course c on r.c_id = c.id
    //where s.name = '刘星';
    Course selectByName2(String name);
}
